Blog
Search
Help
Members
Register
Login
Home
Home
»
SQL & PL/SQL
»
SQL & PL/SQL
»
5th highest salary earner
Show:
Today's Messages
::
Polls
::
Message Navigator
E-mail to friend
5th highest salary earner
[
message #8634
]
Tue, 16 September 2003 05:05
Bipul
Messages:
11
Registered:
June 2003
Junior Member
what is the sql statment to see the 5th highest salary earner in a table.
Report message to a moderator
Re: 5th highest salary earner
[
message #8638
is a reply to
message #8634
]
Tue, 16 September 2003 09:41
Art Metzer
Messages:
2480
Registered:
December 2002
Senior Member
http://www.orafaq.net/msgboard/sql/messages/11276.htm
http://www.orafaq.net/msgboard/sql/messages/15134.htm
http://www.orafaq.net/msgboard/sql/messages/18584.htm
http://www.orafaq.net/msgboard/sql/messages/18586.htm
http://www.orafaq.net/msgboard/sql/messages/18617.htm
http://www.orafaq.net/msgboard/sql/messages/18636.htm
http://www.orafaq.net/msgboard/sql/messages/19061.htm
http://www.orafaq.net/msgboard/sql/messages/20323.htm
http://www.orafaq.net/msgboard/sql/messages/21021.htm
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:587023408954
Report message to a moderator
Re: 5th highest salary earner
[
message #8652
is a reply to
message #8634
]
Wed, 17 September 2003 04:10
R.Satish Kumar
Messages:
14
Registered:
August 2003
Junior Member
Hi,
Here is ur query.
select max(sal) from emp
where level = &no connect by prior sal > sal
Happy querrying..
Satish.R
Report message to a moderator
Previous Topic:
how to find sum of positive salary and sum of negative salary
Next Topic:
EXECUTE IMMEDIATE giving error in Oracle 9i
Goto Forum:
- SQL & PL/SQL
SQL & PL/SQL
- RDBMS Server
Server Administration
Backup & Recovery
Performance Tuning
Security
Networking and Gateways
Enterprise Manager
Server Utilities
- Server Options
RAC & Failsafe
Data Guard
Replication
Streams & AQ
Spatial
Text & interMedia
Multitenant
- Developer & Programmer
Application Express, ORDS & MOD_PLSQL
Forms
Reports & Discoverer
Designer
JDeveloper, Java & XML
Data Integration
Precompilers, OCI & OCCI
- Fusion Middleware & Colab Suite
Weblogic & Application Server
Business Intelligence
WebCenter Suite & Portal
Collaboration & Content Management
SOA Suite, BPEL and OWSM
- Applications
Oracle Fusion Apps & E-Business Suite
PeopleSoft, JD Edwards & Siebel
Primavera
Other Application Suites
- Infrastructure
Cloud and Hosting
Hardware
Linux
Unix
Windows
Other Operating Systems
- Open Source
Programming Interfaces
MySQL
NoSQL
- Other
General
Training & Certification
Client Tools
Marketplace
Community Hangout
News & Blogs
Suggestions & Feedback
Test
- Non-English Forums
Arabic
Dutch
French
German
Japanese
Portuguese
Russian
Spanish
-=]
Back to Top
[=-
[
Syndicate this forum (XML)
] [
]
Current Time:
Fri Sep 20 19:17:38 CDT 2024